/*
 * Tencent is pleased to support the open source community by making BK-CI 蓝鲸持续集成平台 available.
 *
 * Copyright (C) 2019 THL A29 Limited, a Tencent company.  All rights reserved.
 *
 * BK-CI 蓝鲸持续集成平台 is licensed under the MIT license.
 *
 * A copy of the MIT License is included in this file.
 *
 *
 * Terms of the MIT License:
 * ---------------------------------------------------
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
 * documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all copies or substantial portions of
 * the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT
 * LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN
 * NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
 * WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
 * SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 *
 */

package com.tencent.devops.auth.dao

import com.tencent.devops.auth.pojo.vo.AuthItsmCallbackInfo
import com.tencent.devops.model.auth.tables.TAuthItsmCallback
import com.tencent.devops.model.auth.tables.records.TAuthItsmCallbackRecord
import org.jooq.DSLContext
import org.springframework.stereotype.Repository

@Repository
@Suppress("LongParameterList")
class AuthItsmCallbackDao {

    fun create(
        dslContext: DSLContext,
        applyId: Int,
        sn: String,
        englishName: String,
        callbackId: String,
        applicant: String
    ): Int {
        with(TAuthItsmCallback.T_AUTH_ITSM_CALLBACK) {
            return dslContext.insertInto(
                this,
                APPLY_ID,
                SN,
                ENGLISH_NAME,
                CALLBACK_ID,
                APPLICANT
            ).values(
                applyId,
                sn,
                englishName,
                callbackId,
                applicant
            ).execute()
        }
    }

    fun getCallbackBySn(
        dslContext: DSLContext,
        sn: String
    ): TAuthItsmCallbackRecord? {
        with(TAuthItsmCallback.T_AUTH_ITSM_CALLBACK) {
            return dslContext.selectFrom(this).where(SN.eq(sn)).fetchAny()
        }
    }

    fun updateCallbackBySn(
        dslContext: DSLContext,
        sn: String,
        approver: String,
        approveResult: Boolean
    ): Int {
        return with(TAuthItsmCallback.T_AUTH_ITSM_CALLBACK) {
            dslContext.update(this)
                .set(APPROVER, approver)
                .set(APPROVE_RESULT, approveResult)
                .where(SN.eq(sn)).execute()
        }
    }

    fun getCallbackByEnglishName(
        dslContext: DSLContext,
        projectCode: String
    ): TAuthItsmCallbackRecord? {
        with(TAuthItsmCallback.T_AUTH_ITSM_CALLBACK) {
            return dslContext.selectFrom(this)
                .where(ENGLISH_NAME.eq(projectCode))
                .orderBy(CREATE_TIME.desc())
                .fetchAny()
        }
    }

    fun convert(record: TAuthItsmCallbackRecord?): AuthItsmCallbackInfo? {
        return record?.let {
            with(it) {
                AuthItsmCallbackInfo(
                    applyId = applyId,
                    sn = sn,
                    projectId = it.englishName,
                    callbackId = callbackId,
                    applicant = applicant,
                    approver = approver,
                    approveResult = approveResult
                )
            }
        }
    }
}
